<?
/**
* Google Chart API
* author: NetSoul
* http://code.google.com/apis/chart/
*/
class Chartapi
{
	var  $cht='p3'; // http://code.google.com/apis/chart/types.html bvs p3 pc p lc ls lxy bhs bhg bhg bvg chbh chp v s r rs t
	var  $chd;
	var  $chd2;	
	var  $chs='250x100';
	var  $chl;
	var  $chtt;
	var  $chdl;
	var  $chdlp;
	var  $chxt;
	var  $chco;
	var  $chxl;
	var  $type='t';
	var  $chf;
	var  $chg;
	var  $chls;
	var  $chxy;
	var  $chxr;
	
	function Chartapi()
	{
		# construct
	}
	
	function generate($return=true)
	{
		$params=array();$url="?";
		
			if(!is_null($this->cht)) 	$params['cht']=$this->cht;
			if(!is_null($this->chs)) 	$params['chs']=$this->chs;
			if(!is_null($this->chd)) 	{
				if($this->type=='t') $params['chd']=$this->type.':'.implode(',',$this->chd);
				if($this->type=='s') $params['chd']=$this->type.':'.$this->array_to_extended_encoding($this->chd);
				if($this->type=='e') $params['chd']=$this->type.':'.$this->convert($this->chd);
				
			}
			if(!is_null($this->chd2)) 	{
				$chd2=implode(',',$this->chd);
				
			}			
			if(!is_null($this->chl)) 	$params['chl']		=implode('|',$this->chl);
			if(!is_null($this->chls)) 	$params['chls']	=implode(',',$this->chls);
			//if(!is_null($this->chxl)) 	$params['chxl']	='0:|'.implode('|',$this->chxl);
			if(!is_null($this->chxl)) 	$params['chxl']	=$this->chxl;
			if(!is_null($this->chxy)) 	$params['chxy']	='0:|'.implode('|',$this->chxy);
			
			if(!is_null($this->chtt)) 	$params['chtt']	=$this->chtt;
			if(!is_null($this->chxr)) 	$params['chxr']	=$this->chxr;
			if(!is_null($this->chco)) 	$params['chco']	=$this->chco;			
			if(!is_null($this->chxt)) 	$params['chxt']	=$this->chxt;	
			if(!is_null($this->chdlp)) $params['chdlp']	=$this->chdlp;	
			if(!is_null($this->chdl)) 	$params['chdl']	=$this->chdl;			
			if(!is_null($this->chxt)) 	$params['chxt']	=$this->chxt;
			if(!is_null($this->chf)) 	$params['chf']		=$this->chf;			
			if(!is_null($this->chg)) 	$params['chg']		=$this->chg;	
			if(isset($chd2)) $params['chd'].='|'.$chd2;
			foreach ($params as $key => $value) {
				$url.="$key=$value&";
			}
			if($return) return "<img src='http://chart.apis.google.com/chart".substr($url, 0, -1)."'>";
			else echo "<img src='http://chart.apis.google.com/chart".substr($url, 0, -1)."'>";
		
	}
	
	function array_to_extended_encoding($array)
	{
	    $characters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789-.';
	 
	    $encoding = '';
	    foreach ($array as $value) {
	        $first = floor($value / 64);
	        $second = $value % 64;
	        $encoding .= $characters[$first] . $characters[$second];
	    }
	 
	    return $encoding;
	}
	
	function extended_encoding_to_array($string)
	{
	    $characters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789-.';  
	 
	    for ($i=0;$i<strlen($characters);$i++) {
	        $first[$characters[$i]] = $i * 64;
	    }
	 
	    for ($i=0;$i<strlen($characters);$i++) {
	        $second[$characters[$i]] = $i;
	    }
	 
	    $pairs = str_split($string,2);
	    foreach ($pairs as $pair) {
	        $value = $first[$pair[0]];
	        $value += $second[$pair[1]];
	        $values[] = $value;
	    }
	 
	    return $values;
	}	
	
	function convert($nValue)
    {
        // This code will be slow, and should be replaced with a mathematical algorithm
        
        assert($nValue >= 0);
                            
        $aMask = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L',
                        'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X',
                        'Y', 'Z', 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 
                        'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 
                        'w', 'x', 'y', 'z', '0', '1', '2', '3', '4', '5', '6', '7', 
                        '8', '9', '-', '.');
        
        $iLength = count($aMask);                     
        $iCount = 0;        
            
        for ($i = 0; $i < $iLength; $i++)
        {         
            for ($j = 0; $j < $iLength; $j++)
            {
                if ($nValue == $iCount)
                {
                    return $aMask[$i] . $aMask[$j];
                }

                $iCount++;
            }
        }
                            
        return '__';
    }	
}
class CI_Table {

	var $rows				= array();
	var $heading			= array();
	var $auto_heading		= TRUE;	
	var $caption			= NULL;	
	var $template 			= NULL;
	var $newline			= "\n";
	var $empty_cells		= "";
	
	
	function CI_Table()
	{
		
	}

	// --------------------------------------------------------------------

	/**
	 * Set the template
	 *
	 * @access	public
	 * @param	array
	 * @return	void
	 */
	function set_template($template)
	{
		if ( ! is_array($template))
		{
			return FALSE;
		}
	
		$this->template = $template;
	}

	// --------------------------------------------------------------------

	/**
	 * Set the table heading
	 *
	 * Can be passed as an array or discreet params
	 *
	 * @access	public
	 * @param	mixed
	 * @return	void
	 */
	function set_heading()
	{
		$args = func_get_args();
		$this->heading = (is_array($args[0])) ? $args[0] : $args;
	}

	// --------------------------------------------------------------------

	/**
	 * Set columns.  Takes a one-dimensional array as input and creates
	 * a multi-dimensional array with a depth equal to the number of
	 * columns.  This allows a single array with many elements to  be
	 * displayed in a table that has a fixed column count.
	 *
	 * @access	public
	 * @param	array
	 * @param	int
	 * @return	void
	 */
	function make_columns($array = array(), $col_limit = 0)
	{
		if ( ! is_array($array) OR count($array) == 0)
		{
			return FALSE;
		}
		
		// Turn off the auto-heading feature since it's doubtful we 
		// will want headings from a one-dimensional array
		$this->auto_heading = FALSE;
		
		if ($col_limit == 0)
		{
			return $array;
		}
	
		$new = array();
		while(count($array) > 0)
		{	
			$temp = array_splice($array, 0, $col_limit);
			
			if (count($temp) < $col_limit)
			{
				for ($i = count($temp); $i < $col_limit; $i++)
				{
					$temp[] = '&nbsp;';
				}
			}
			
			$new[] = $temp;
		}
		
		return $new;
	}

	// --------------------------------------------------------------------

	/**
	 * Set "empty" cells
	 *
	 * Can be passed as an array or discreet params
	 *
	 * @access	public
	 * @param	mixed
	 * @return	void
	 */
	function set_empty($value)
	{
		$this->empty_cells = $value;
	}
	
	// --------------------------------------------------------------------

	/**
	 * Add a table row
	 *
	 * Can be passed as an array or discreet params
	 *
	 * @access	public
	 * @param	mixed
	 * @return	void
	 */
	function add_row()
	{
		$args = func_get_args();
		$this->rows[] = (is_array($args[0])) ? $args[0] : $args;
	}

	// --------------------------------------------------------------------

	/**
	 * Add a table caption
	 *
	 * @access	public
	 * @param	string
	 * @return	void
	 */
	function set_caption($caption)
	{
		$this->caption = $caption;
	}	

	// --------------------------------------------------------------------

	/**
	 * Generate the table
	 *
	 * @access	public
	 * @param	mixed
	 * @return	string
	 */
	function generate($table_data = NULL)
	{
		// The table data can optionally be passed to this function
		// either as a database result object or an array
		if ( ! is_null($table_data))
		{
			if (is_object($table_data))
			{
				$this->_set_from_object($table_data);
			}
			elseif (is_array($table_data))
			{
				$set_heading = (count($this->heading) == 0 AND $this->auto_heading == FALSE) ? FALSE : TRUE;
				$this->_set_from_array($table_data, $set_heading);
			}
		}
	
		// Is there anything to display?  No?  Smite them!
		if (count($this->heading) == 0 AND count($this->rows) == 0)
		{
			return 'Undefined table data';
		}
	
		// Compile and validate the template date
		$this->_compile_template();
	
	
		// Build the table!
		
		$out = $this->template['table_open'];
		$out .= $this->newline;		

		// Add any caption here
		if ($this->caption)
		{
			$out .= $this->newline;
			$out .= '<caption>' . $this->caption . '</caption>';
			$out .= $this->newline;
		}

		// Is there a table heading to display?
		if (count($this->heading) > 0)
		{
			$out .= $this->template['heading_row_start'];
			$out .= $this->newline;		

			foreach($this->heading as $heading)
			{
				$out .= $this->template['heading_cell_start'];
				$out .= $heading;
				$out .= $this->template['heading_cell_end'];
			}

			$out .= $this->template['heading_row_end'];
			$out .= $this->newline;				
		}

		// Build the table rows
		if (count($this->rows) > 0)
		{
			$i = 1;
			foreach($this->rows as $row)
			{
				if ( ! is_array($row))
				{
					break;
				}
			
				// We use modulus to alternate the row colors
				$name = (fmod($i++, 2)) ? '' : 'alt_';
			
				$out .= $this->template['row_'.$name.'start'];
				$out .= $this->newline;		
	
				foreach($row as $cell)
				{
					$out .= $this->template['cell_'.$name.'start'];
					
					if ($cell === "")
					{
						$out .= $this->empty_cells;
					}
					else
					{
						$out .= $cell;
					}
					
					$out .= $this->template['cell_'.$name.'end'];
				}
	
				$out .= $this->template['row_'.$name.'end'];
				$out .= $this->newline;	
			}
		}

		$out .= $this->template['table_close'];
	
		return $out;
	}
	
	// --------------------------------------------------------------------

	/**
	 * Clears the table arrays.  Useful if multiple tables are being generated
	 *
	 * @access	public
	 * @return	void
	 */
	function clear()
	{
		$this->rows				= array();
		$this->heading			= array();
		$this->auto_heading		= TRUE;	
	}
	
	// --------------------------------------------------------------------

	/**
	 * Set table data from a database result object
	 *
	 * @access	public
	 * @param	object
	 * @return	void
	 */
	function _set_from_object($query)
	{
		if ( ! is_object($query))
		{
			return FALSE;
		}
		
		// First generate the headings from the table column names
		if (count($this->heading) == 0)
		{
			if ( ! method_exists($query, 'list_fields'))
			{
				return FALSE;
			}
			
			$this->heading = $query->list_fields();
		}
				
		// Next blast through the result array and build out the rows
		
		if ($query->num_rows() > 0)
		{
			foreach ($query->result_array() as $row)
			{
				$this->rows[] = $row;
			}
		}
	}

	// --------------------------------------------------------------------

	/**
	 * Set table data from an array
	 *
	 * @access	public
	 * @param	array
	 * @return	void
	 */
	function _set_from_array($data, $set_heading = TRUE)
	{
		if ( ! is_array($data) OR count($data) == 0)
		{
			return FALSE;
		}
		
		$i = 0;
		foreach ($data as $row)
		{
			if ( ! is_array($row))
			{
				$this->rows[] = $data;
				break;
			}
						
			// If a heading hasn't already been set we'll use the first row of the array as the heading
			if ($i == 0 AND count($data) > 1 AND count($this->heading) == 0 AND $set_heading == TRUE)
			{
				$this->heading = $row;
			}
			else
			{
				$this->rows[] = $row;
			}
			
			$i++;
		}
	}

	// --------------------------------------------------------------------

	/**
	 * Compile Template
	 *
	 * @access	private
	 * @return	void
	 */
 	function _compile_template()
 	{ 	
 		if ($this->template == NULL)
 		{
 			$this->template = $this->_default_template();
 			return;
 		}
		
		$this->temp = $this->_default_template();
		foreach (array('table_open','heading_row_start', 'heading_row_end', 'heading_cell_start', 'heading_cell_end', 'row_start', 'row_end', 'cell_start', 'cell_end', 'row_alt_start', 'row_alt_end', 'cell_alt_start', 'cell_alt_end', 'table_close') as $val)
		{
			if ( ! isset($this->template[$val]))
			{
				$this->template[$val] = $this->temp[$val];
			}
		} 	
 	}
	
	// --------------------------------------------------------------------

	/**
	 * Default Template
	 *
	 * @access	private
	 * @return	void
	 */
	function _default_template()
	{
		return  array (
						'table_open' 			=> '<table border="0" cellpadding="4" cellspacing="0">',

						'heading_row_start' 	=> '<tr>',
						'heading_row_end' 		=> '</tr>',
						'heading_cell_start'	=> '<th>',
						'heading_cell_end'		=> '</th>',

						'row_start' 			=> '<tr>',
						'row_end' 				=> '</tr>',
						'cell_start'			=> '<td>',
						'cell_end'				=> '</td>',

						'row_alt_start' 		=> '<tr>',
						'row_alt_end' 			=> '</tr>',
						'cell_alt_start'		=> '<td>',
						'cell_alt_end'			=> '</td>',

						'table_close' 			=> '</table>'
					);	
	}
	

}